print "\n";
$sql = "select eid,cmd,label,datedone from experiment where owner = $uid $foldersql order by datedone desc";
print "";
$sqlh = mysql_query($sql);
if ($sqlh and (mysql_num_rows($sqlh) > 0)) {
?>
Your saved experiments are : |
$i = 0;
while ($i < mysql_num_rows($sqlh)) {
?>
print $login ?> |
print stripslashes(mysql_result($sqlh,$i,'label')) ?> |
print mysql_result($sqlh,$i,'datedone') ?> |
More info |
Run this model |
$i = $i + 1;
} # looping through results
} # valid results present
?>
|
if ($folderid == 0) {
$sql = "select foldername,login,folderid,folderowner from folder,user where folderowner = uid order by foldername";
$res = mysql_query($sql);
if ($res && (mysql_num_rows($res) > 0 )) {
?>
Experiment folders: |
$i = 0;
while ($i < mysql_num_rows($res) ) {
$foldername = mysql_result($res,$i,'foldername');
$folderownername = mysql_result($res,$i,'login');
$folderownerid = mysql_result($res,$i,'folderowner');
$folderid = mysql_result($res,$i,'folderid');
?>
print $folderownername ?> |
print $foldername ?> |
|
More info |
Open folder |
$i = $i + 1;
} # end loop through results
?>
|
} # end valid results foune
} # not already in a folder
?>
Shared experiments from others: |
$sql = "select experiment.eid as eid,cmd,label,datedone,owner,login,user.uid from rights,experiment,user where power > 0 and
rights.eid = experiment.eid and owner = user.uid and user.uid <> $uid $foldersql order by datedone desc";
print "\n\n";
$res2 = mysql_query($sql);
if ($res2 && (mysql_num_rows($res2) > 0)) {
$i = 0;
while ($i < mysql_num_rows($res2)) {
if (mysql_result($res2,$i,'owner') != $login) {
?>
print mysql_result($res2,$i,'login') ?> |
print stripslashes(mysql_result($res2,$i,'label')) ?> |
print mysql_result($res2,$i,'datedone') ?> |
More info |
Run this model |
} # I don't own this experiment
$i = $i + 1;
} # looping through results
} #valid results present.
?>